Create Line and Clustered Chart for Total Accidents by Year, Month and Weekday 14

Our second chart is a line and clustered chart for the Total Accidents by year, month and weekday. Please follow detailed steps and format options shown below


Step 1: In the visualization pane, select the Line and stacked column chart. In the 'MyMeasures' Table, click 'AccidentsPerDay' and 'HighSeverityPerDay' as Column values. Drag and drop %YOYHighSeverity and %YOYAccidentsPerDay into the Line values. In The Date table, click on the Date dropdown to reveal the Date hierarchy, then click on 'Year' and 'Month' to the Shared axis. Finally, drag and drop 'DayofWeekName' to the shared axis.



Step 2: Format chart using the screenshots and GIF below as a guide

I. General

II. X axis and Y axis


III. Data Colors

IV. Data Labels


V. Shapes, background and shadow


VI. Title


VII. Move HighSeverityPerDay on top of AccidentsPerDay (See GIF below)




Step 3: If you drill the chart down to WeekDay, you will notice it is not properly sorted. To sort this, right click on the Date Table then click 'New Column. Copy and paste the DAX equation below then click on the  icon (See GIF below)

WeekDay = WEEKDAY('Date'[Date], 2)

Now click on the chart, then click DayOfWeekName to show the Column tools on top of the page. Click 'Sort by column', then click WeekDay. (See GIF below)



For tips on how to create and use combo chart in Power BI, visit: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

For tips on how to sort Date column by Week in Power BI, visit:  https://insightsoftware.com/blog/working-with-weeks-in-power-bi/#:~:text=To%20sort%20the%20days%20properly,and%20finally%20select%20Week%E2%80%93day.